﻿/**
 * This stored procedure aims to insert ALL the needed data for Zen4Sync testing.
 * If you need data in the database for your tests, THIS is the place to be.
 */
CREATE PROCEDURE [Admin].[sp_z4s_insert_test_data_IEntityProvider]
AS

INSERT INTO [Admin].[testSessionCategory]
           ([testSessionCategory_id]
           ,[testSessionCategory_name])
     VALUES
           ('1CEC441C-D2EF-4E10-AEEF-549B4D25704A'
           ,'testSessionCategoryName1')

INSERT INTO [Admin].[testSessionState]
            ([testSessionState_id]
            ,[testSessionState_name])
    VALUES('4FA8D009-D720-44FA-BEDA-1192EA6086E8'
           ,'Planned')

INSERT INTO [Admin].[testSession]
           ([testSession_id]
           ,[testSession_name]
           ,[testSession_createdOn]
           ,[testSession_testSessionCategoryId]
           ,[testSession_testSessionStateId])
     VALUES
           ('2C3C988A-675C-42D1-ACC5-D111E04D1F88'
           ,'TestSessionName1'
           ,CAST('2010-04-01 17:19:23.62' AS datetime)
           ,'1CEC441C-D2EF-4E10-AEEF-549B4D25704A'
           ,'4FA8D009-D720-44FA-BEDA-1192EA6086E8')

INSERT INTO [Admin].[testSession]
           ([testSession_id]
           ,[testSession_name]
           ,[testSession_createdOn]
           ,[testSession_testSessionCategoryId]
           ,[testSession_testSessionStateId])
     VALUES
           ('47224433-950B-4A2B-B9BB-B188FD5BCFC1'
           ,'TestSessionName2'
           ,CAST('2011-04-01 17:19:23.62' AS datetime)
           ,'1CEC441C-D2EF-4E10-AEEF-549B4D25704A'
           ,'4FA8D009-D720-44FA-BEDA-1192EA6086E8')

INSERT INTO [Admin].[testServer]
           ([testServer_Id]
           ,[testServer_name]
           ,[testServer_hostName]
           ,[testServer_wcfConfigSectionName]
           ,[testServer_loadSyncApplicationPath]
           ,[testServer_configFilesDirectory]
           ,[testServer_mefComponentRootDirectory])
     VALUES
           ('4C439FF8-EE20-46C8-959A-250170B231F6'
           ,'TestServerName_1'
           ,'TestServerHostName_1'
           ,'TestServerwcfConfigSectionName_1'
           ,'TestServerloadSyncApplicationPath_1'
           ,'TestServerconfigFilesDirectory_1'
           ,null)

INSERT INTO [Admin].[testServer]
           ([testServer_Id]
           ,[testServer_name]
           ,[testServer_hostName]
           ,[testServer_wcfConfigSectionName]
           ,[testServer_loadSyncApplicationPath]
           ,[testServer_configFilesDirectory]
           ,[testServer_mefComponentRootDirectory])
     VALUES
           ('72691EF7-EBEA-4B32-BA50-C1D1B6318488'
           ,'TestServerName_2'
           ,'TestServerHostName_2'
           ,'TestServerwcfConfigSectionName_2'
           ,'TestServerloadSyncApplicationPath_2'
           ,'TestServerconfigFilesDirectory_2'
           ,null)

INSERT INTO [Scenario].[testScenario]
           ([testScenario_id]
           ,[testScenario_name])
     VALUES
           ('F5062C6D-C6F2-4995-BFFB-37EC4B9AB442'
           ,'clientAcitvityScenarioName_1')

INSERT INTO [Scenario].[testScenario]
           ([testScenario_id]
           ,[testScenario_name])
     VALUES
           ('A65775BB-45B6-4FA7-B83B-7D6018719AF2'
           ,'clientAcitvityScenarioName_2')

-- Will be returned
INSERT INTO [Admin].[clientSession]
           ([clientSession_id]
           ,[clientSession_name]
           ,[clientSession_testServerId]
           ,[clientSession_testSessionId]
           ,[clientSession_enableLog]
           ,[clientSession_scheduledStartDateTime]
           ,[clientSession_testScenarioId]
           ,[clientSession_readyToStart]
           ,[clientSession_readyToStartDateTime]
           ,[clientSession_readyToStartDateTimeOnServer]
           ,[clientSession_processId]
           ,[clientSession_startDateTime]
           ,[clientSession_startDateTimeOnServer]
           ,[clientSession_endDateTime]
           ,[clientSession_endDateTimeOnServer]
           ,[clientSession_error])
     VALUES
           ('87843D09-C873-45DA-8E0E-B66A30D719A6'
           ,'ClientSessionName_1'
           ,'4C439FF8-EE20-46C8-959A-250170B231F6'
           ,'2C3C988A-675C-42D1-ACC5-D111E04D1F88'
           ,'1'
           ,CAST('2011-04-01 17:19:23.62' AS datetime)
           ,'F5062C6D-C6F2-4995-BFFB-37EC4B9AB442'
           ,'1'
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null)

--will not be returned couse the testServer id isn't the good one
INSERT INTO [Admin].[clientSession]
           ([clientSession_id]
           ,[clientSession_name]
           ,[clientSession_testServerId]
           ,[clientSession_testSessionId]
           ,[clientSession_enableLog]
           ,[clientSession_scheduledStartDateTime]
           ,[clientSession_testScenarioId]
           ,[clientSession_readyToStart]
           ,[clientSession_readyToStartDateTime]
           ,[clientSession_readyToStartDateTimeOnServer]
           ,[clientSession_processId]
           ,[clientSession_startDateTime]
           ,[clientSession_startDateTimeOnServer]
           ,[clientSession_endDateTime]
           ,[clientSession_endDateTimeOnServer]
           ,[clientSession_error])
     VALUES
           ('394D95DC-FA1B-483F-B889-7712D6F8F614'
           ,'ClientSessionName_2'
           ,'72691EF7-EBEA-4B32-BA50-C1D1B6318488'
           ,'2C3C988A-675C-42D1-ACC5-D111E04D1F88'
           ,'1'
           ,CAST('2010-04-01 17:19:23.62' AS datetime)
           ,'F5062C6D-C6F2-4995-BFFB-37EC4B9AB442'
           ,'1'
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null)

--will not be returned couse the testSession id isn't the good one
INSERT INTO [Admin].[clientSession]
           ([clientSession_id]
           ,[clientSession_name]
           ,[clientSession_testServerId]
           ,[clientSession_testSessionId]
           ,[clientSession_enableLog]
           ,[clientSession_scheduledStartDateTime]
           ,[clientSession_testScenarioId]
           ,[clientSession_readyToStart]
           ,[clientSession_readyToStartDateTime]
           ,[clientSession_readyToStartDateTimeOnServer]
           ,[clientSession_processId]
           ,[clientSession_startDateTime]
           ,[clientSession_startDateTimeOnServer]
           ,[clientSession_endDateTime]
           ,[clientSession_endDateTimeOnServer]
           ,[clientSession_error])
     VALUES
           ('2C812317-4D19-4100-8140-F0B57A107DA7'
           ,'ClientSessionName_3'
           ,'4C439FF8-EE20-46C8-959A-250170B231F6'
           ,'47224433-950B-4A2B-B9BB-B188FD5BCFC1'
           ,'1'
           ,CAST('2009-04-01 17:19:23.62' AS datetime)
           ,'F5062C6D-C6F2-4995-BFFB-37EC4B9AB442'
           ,'1'
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null)

--will not be returned couse the testServer id and testSession id aren't the good ones
INSERT INTO [Admin].[clientSession]
           ([clientSession_id]
           ,[clientSession_name]
           ,[clientSession_testServerId]
           ,[clientSession_testSessionId]
           ,[clientSession_enableLog]
           ,[clientSession_scheduledStartDateTime]
           ,[clientSession_testScenarioId]
           ,[clientSession_readyToStart]
           ,[clientSession_readyToStartDateTime]
           ,[clientSession_readyToStartDateTimeOnServer]
           ,[clientSession_processId]
           ,[clientSession_startDateTime]
           ,[clientSession_startDateTimeOnServer]
           ,[clientSession_endDateTime]
           ,[clientSession_endDateTimeOnServer]
           ,[clientSession_error])
     VALUES
           ('C75934D8-9F52-4AC9-A134-002C4983550B'
           ,'ClientSessionName_4'
           ,'72691EF7-EBEA-4B32-BA50-C1D1B6318488'
           ,'47224433-950B-4A2B-B9BB-B188FD5BCFC1'
           ,'1'
           ,CAST('2009-04-01 17:19:23.62' AS datetime)
           ,'A65775BB-45B6-4FA7-B83B-7D6018719AF2'
           ,'1'
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null
           ,null)

/* SQL CE Backup Activity */
INSERT INTO [SQLCEBackup].[sqlceBackup]
           ([sqlceBackup_id])
     VALUES
           ('9F0F8A74-6F59-41EF-A283-E0C8409C57AD')

INSERT INTO [SQLCEBackup].[sqlceBackupContext]
           ([sqlceBackupContext_id]
           ,[sqlceBackupContext_name]
           ,[sqlceBackupContext_sdfFileName]
           ,[sqlceBackupContext_sdfFileDirectory])
     VALUES
           ('C3644FD9-EBEE-492E-89F7-74F468BCE6D5'
           ,'sqlceBackupContextName'
           ,'sdfFileName'
           ,'sdfFileDirectory')

INSERT INTO [Scenario].[activity]
           ([activity_id]
           ,[activity_testScenarioId]
           ,[activity_activityTypeId]
           ,[activity_activityItemId]
           ,[activity_executionOrder]
           ,[activity_preWaitingTimeInSeconds]
           ,[activity_postWaitingTimeInSeconds])
     VALUES
           ('1275E750-951D-4F31-A1A4-1E9CF5A4D722'
           ,'F5062C6D-C6F2-4995-BFFB-37EC4B9AB442'
           ,'5B03C91F-81B0-4360-A483-5666F3B31E16'
           ,'9F0F8A74-6F59-41EF-A283-E0C8409C57AD'
           ,'1'
           ,'0'
           ,'0')

INSERT INTO [Scenario].[activityContext]
           ([activityContext_id]
           ,[activityContext_activityId]
           ,[activityContext_clientSessionId]
           ,[activityContext_contextItemId]
           ,[activityContext_overridingData])
     VALUES
           ('01E27B63-FA12-47BA-A42B-81A890D4B978'
           ,'1275E750-951D-4F31-A1A4-1E9CF5A4D722'
           ,'87843D09-C873-45DA-8E0E-B66A30D719A6'
           ,'C3644FD9-EBEE-492E-89F7-74F468BCE6D5'
           ,'overridingData.xml')
/* END SQL CE Backup Activity */

/* SQL Server Check Data Activity */
INSERT INTO [SQLServerExecution].[sqlServerCheckData]
           ([sqlServerCheckData_id]
           ,[sqlServerCheckData_name]
           ,[sqlServerCheckData_sqlQuery]
           ,[sqlServerCheckData_expectedValue]
           ,[sqlServerCheckData_sqlValueTypeId])
     VALUES
           ('29FC5A45-F0F1-41AC-9E49-FC8AAB7827FE'
           ,'sqlServerCheckDataName'
           ,'sqlQuery,'
           ,CONVERT(varbinary(MAX), 'expectedValue')
           ,'f7ad067b-06ab-41d9-89ad-7152b32f127e')

INSERT INTO [SQLServerExecution].[sqlServerCheckDataContext]
           ([sqlServerCheckDataContext_id]
           ,[sqlServerCheckDataContext_name]
           ,[sqlServerCheckDataContext_connectionString]
           ,[sqlServerCheckDataContext_isEncryptedConnectionString])
     VALUES
           ('DFF6F7B3-1A3F-4FDE-A439-15BFD0EE0679'
           ,'sqlServerCheckDataContextName'
           ,convert(varbinary(MAX),'connectionString')
           ,'0')

INSERT INTO [SQLServerExecution].[sqlServerCheckDataParameter]
           ([sqlServerCheckDataParameter_id]
           ,[sqlServerCheckDataParameter_name]
           ,[sqlServerCheckDataParameter_value]
           ,[sqlServerCheckDataParameter_sqlValueTypeId]
           ,[sqlServerCheckDataParameter_sqlServerCheckDataContext])
     VALUES
           ('3B695E10-F917-4898-B915-09E39D95E178'
           ,'sqlServerCheckDataParameterName'
           ,CONVERT(varbinary(MAX), 'sqlServerCheckDataParameterValue')
           ,'f7ad067b-06ab-41d9-89ad-7152b32f127e'
           ,'DFF6F7B3-1A3F-4FDE-A439-15BFD0EE0679')

INSERT INTO [Scenario].[activity]
           ([activity_id]
           ,[activity_testScenarioId]
           ,[activity_activityTypeId]
           ,[activity_activityItemId]
           ,[activity_executionOrder]
           ,[activity_preWaitingTimeInSeconds]
           ,[activity_postWaitingTimeInSeconds])
     VALUES
           ('F42DE5E1-C050-40AF-B2CB-8A02F06BFA28'
           ,'F5062C6D-C6F2-4995-BFFB-37EC4B9AB442'
           ,'7E662C4A-F0B0-490C-808D-C9E5B7867C90'
           ,'29FC5A45-F0F1-41AC-9E49-FC8AAB7827FE'
           ,'2'
           ,'0'
           ,'0')

INSERT INTO [Scenario].[activityContext]
           ([activityContext_id]
           ,[activityContext_activityId]
           ,[activityContext_clientSessionId]
           ,[activityContext_contextItemId]
           ,[activityContext_overridingData])
     VALUES
           ('B8DADA4D-D23D-4D5F-88B0-FE291CD1644D'
           ,'F42DE5E1-C050-40AF-B2CB-8A02F06BFA28'
           ,'87843D09-C873-45DA-8E0E-B66A30D719A6'
           ,'DFF6F7B3-1A3F-4FDE-A439-15BFD0EE0679'
           ,'overridingData.xml')
/* END SQL Server Check Data Activity */

/* SQL CE Check Data Activity */
INSERT INTO [SQLCEExecution].[sqlceCheckData]
           ([sqlceCheckData_id]
           ,[sqlceCheckData_name]
           ,[sqlceCheckData_sqlQuery]
           ,[sqlceCheckData_expectedValue]
           ,[sqlceCheckData_sqlValueTypeId])
     VALUES
           ('10B76474-A7B8-42B9-9A04-501E9E917018'
           ,'sqlServerCheckDataName'
           ,'sqlQuery'
           ,CONVERT(varbinary(MAX), 'expectedValue')
           ,'f7ad067b-06ab-41d9-89ad-7152b32f127e')

INSERT INTO [SQLCEExecution].[sqlceCheckDataContext]
           ([sqlceCheckDataContext_id]
           ,[sqlceCheckDataContext_name]
           ,[sqlceCheckDataContext_connectionString]
           ,[sqlceCheckDataContext_isEncryptedConnectionString])
     VALUES
           ('A574EE4F-F614-46B9-9B4B-B505195C630D'
           ,'sqlceCheckDataContextName'
           ,convert(varbinary(MAX),'connectionString')
           ,'0')

INSERT INTO [SQLCEExecution].[sqlceCheckDataParameter]
           ([sqlceCheckDataParameter_id]
           ,[sqlceCheckDataParameter_name]
           ,[sqlceCheckDataParameter_value]
           ,[sqlceCheckDataParameter_sqlValueTypeId]
           ,[sqlceCheckDataParameter_sqlceCheckDataContextId])
     VALUES
           ('F536ED3E-2558-41C9-BF20-8BF38CE71863'
           ,'sqlceCheckDataParameter_name'
           ,CONVERT(varbinary(MAX), 'sqlceCheckDataParameterValue')
           ,'f7ad067b-06ab-41d9-89ad-7152b32f127e'
           ,'A574EE4F-F614-46B9-9B4B-B505195C630D')

INSERT INTO [Scenario].[activity]
           ([activity_id]
           ,[activity_testScenarioId]
           ,[activity_activityTypeId]
           ,[activity_activityItemId]
           ,[activity_executionOrder]
           ,[activity_preWaitingTimeInSeconds]
           ,[activity_postWaitingTimeInSeconds])
     VALUES
           ('C9886FDE-C4A1-4947-BB7D-02FF1D6D7BE6'
           ,'A65775BB-45B6-4FA7-B83B-7D6018719AF2'
           ,'9DB2B54E-7CD2-4F3E-B15B-1434EAB2BE50'
           ,'10B76474-A7B8-42B9-9A04-501E9E917018'
           ,'1'
           ,'0'
           ,'0')

INSERT INTO [Scenario].[activityContext]
           ([activityContext_id]
           ,[activityContext_activityId]
           ,[activityContext_clientSessionId]
           ,[activityContext_contextItemId]
           ,[activityContext_overridingData])
     VALUES
           ('7C6F04CD-2D80-4390-BBCB-0C083639F208'
           ,'C9886FDE-C4A1-4947-BB7D-02FF1D6D7BE6'
           ,'C75934D8-9F52-4AC9-A134-002C4983550B'
           ,'A574EE4F-F614-46B9-9B4B-B505195C630D'
           ,'overridingData.xml')
/* END SQL CE Check Data Activity */


/* Sync Session Activity */
INSERT INTO [MergeSync].[publisher]
           ([publisher_id]
           ,[publisher_name]
           ,[publisher_address]
           ,[publisher_database]
           ,[publisher_login]
           ,[publisher_password]
           ,[publisher_networkTypeId]
           ,[publisher_securityTypeId])
     VALUES
           ('05C54B7E-65FE-403F-88ED-F35AA7194ED6'
           ,'publisher_name'
           ,'publisher_address'
           ,'publisher_database'
           ,NULL
           ,NULL
           ,'9BAD68FE-1402-4BA3-84CB-5B38A4DBC640'
           ,'53F061F4-C984-4E60-AFB4-BB84CC828F17')

INSERT INTO [MergeSync].[distributor]
           ([distributor_id]
           ,[distributor_name]
           ,[distributor_address]
           ,[distributor_login]
           ,[distributor_password]
           ,[distributor_networkTypeId]
           ,[distributor_securityTypeId]
           ,[distributor_profileName])
     VALUES
           ('5F193191-68EB-485D-88A3-16D81A133CEB'
           ,'<distributor_name, nvarchar(255),>'
           ,'<distributor_address, nvarchar(2000),>'
           ,NULL
           ,NULL
           ,'9BAD68FE-1402-4BA3-84CB-5B38A4DBC640'
           ,'53F061F4-C984-4E60-AFB4-BB84CC828F17'
           ,'DEFAULT')

INSERT INTO [MergeSync].[internet]
           ([internet_id]
           ,[internet_name]
           ,[internet_url]
           ,[internet_login]
           ,[internet_password]
           ,[internet_proxyServer]
           ,[internet_proxyLogin]
           ,[internet_proxyPassword])
     VALUES
           ('00C47ABE-01F3-4D6E-A39D-97B0B2620ABE'
           ,'internet_name'
           ,'internet_url'
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,NULL)

INSERT INTO [MergeSync].[syncSession]
           ([syncSession_id]
           ,[syncSession_compressionLevel]
           ,[syncSession_connectionRetryTimeout]
           ,[syncSession_connectTimeout]
           ,[syncSession_exchangeTypeId]
           ,[syncSession_hostName]
           ,[syncSession_loginTimeout]
           ,[syncSession_postSyncCleanup]
           ,[syncSession_publication]
           ,[syncSession_queryTimeout]
           ,[syncSession_receiveTimeout]
           ,[syncSession_sendTimeout]
           ,[syncSession_snapshotTransferTypeId]
           ,[syncSession_publisherId]
           ,[syncSession_distributorId]
           ,[syncSession_internetId])
     VALUES
           ('2B2BE227-2C90-42F8-9332-B3219C848B97'
           ,'1'
           ,'120'
           ,'0'
           ,'06180660-667A-4004-879A-0B415EEB5415'
           ,'hostName'
           ,'15'
           ,'0'
           ,'publication'
           ,'300'
           ,'60000'
           ,'0'
           ,'85E81462-571F-44A8-BC8C-CB012530DD93'
           ,'05C54B7E-65FE-403F-88ED-F35AA7194ED6'
           ,'5F193191-68EB-485D-88A3-16D81A133CEB'
           ,'00C47ABE-01F3-4D6E-A39D-97B0B2620ABE')

INSERT INTO [MergeSync].[subscriber]
           ([subscriber_id]
           ,[subscriber_name]
           ,[subscriber_hostName]
           ,[subscriber_connectionString]
           ,[subscriber_deleteSdfIfItExists]
           ,[subscriber_sdfFileName]
           ,[subscriber_sdfFileDirectory]
           ,[subscriber_validateTypeId]
           ,[subscriber_reinitializeSubscription]
           ,[subscriber_uploadBeforeReinitialize])
     VALUES
           ('C25573CB-1D1F-458A-88F4-AB4AB4F952B9'
           ,'subscriber_name'
           ,'subscriber_hostName'
           ,'subscriber_connectionString'
           ,'1'
           ,'subscriber_sdfFileName'
           ,'subscriber_sdfFileDirectory'
           ,'11A7D431-3741-4DD3-AFCA-CE8F099C7C66'
           ,0
           ,0)

INSERT INTO [MergeSync].[syncSessionContext]
           ([syncSessionContext_id]
           ,[syncSessionContext_name]
           ,[syncSessionContext_subscriberId])
     VALUES
           ('823A1687-11B0-426F-BD08-0827B4AFD64D'
           ,'syncSessionContextName'
           ,'C25573CB-1D1F-458A-88F4-AB4AB4F952B9')

INSERT INTO [Scenario].[activity]
           ([activity_id]
           ,[activity_testScenarioId]
           ,[activity_activityTypeId]
           ,[activity_activityItemId]
           ,[activity_executionOrder]
           ,[activity_preWaitingTimeInSeconds]
           ,[activity_postWaitingTimeInSeconds])
     VALUES
           ('90623B97-C485-4084-8FF3-6D16CAFF3085'
           ,'A65775BB-45B6-4FA7-B83B-7D6018719AF2'
           ,'4B719513-D6D7-40F7-BBAC-D5E45745F183'
           ,'2B2BE227-2C90-42F8-9332-B3219C848B97'
           ,'1'
           ,'0'
           ,'0')

INSERT INTO [Scenario].[activityContext]
           ([activityContext_id]
           ,[activityContext_activityId]
           ,[activityContext_clientSessionId]
           ,[activityContext_contextItemId]
           ,[activityContext_overridingData])
     VALUES
           ('98A7240A-6EED-47EA-948A-4D950CA3C63E'
           ,'90623B97-C485-4084-8FF3-6D16CAFF3085'
           ,'C75934D8-9F52-4AC9-A134-002C4983550B'
           ,'823A1687-11B0-426F-BD08-0827B4AFD64D'
           ,'overridingData.xml')
/* END Sync Session Activity */

/* MEF Execution Activity */
INSERT INTO [MEF].[mefComponent]
           ([mefComponent_id]
           ,[mefComponent_name])
     VALUES
           ('BDBF6537-EDA4-475D-BA70-127A43579093'
           ,'mefComponentName')

INSERT INTO [MEF].[mefComponentVersion]
           ([mefComponentVersion_id]
           ,[mefComponentVersion_mefComponentId]
           ,[mefComponentVersion_version]
           ,[mefComponentVersion_dll])
     VALUES
           ('012141B9-1426-43F9-957B-18E6AF7939E5'
           ,'BDBF6537-EDA4-475D-BA70-127A43579093'
           ,'version'
           ,CONVERT(varbinary(MAX), 'dll'))

INSERT INTO [MEF].[mefExecution]
           ([mefExecution_id]
           ,[mefExecution_mefComponentVersionId]
           ,[mefExecution_metadata])
     VALUES
           ('9774766B-F49A-46B9-870A-8203D7F04B1C'
           ,'012141B9-1426-43F9-957B-18E6AF7939E5'
           ,'metadata.xml')

INSERT INTO [MEF].[mefExecutionContext]
           ([mefExecutionContext_id]
           ,[mefExecutionContext_name]
           ,[mefExecutionContext_metadata])
     VALUES
           ('40D9B3A2-A775-4404-83D0-8E630CB1CEB6'
           ,'mefExecutionContextName'
           ,'metadata.xml')

INSERT INTO [Scenario].[activity]
            ([activity_id]
           ,[activity_testScenarioId]
           ,[activity_activityTypeId]
           ,[activity_activityItemId]
           ,[activity_executionOrder]
           ,[activity_preWaitingTimeInSeconds]
           ,[activity_postWaitingTimeInSeconds])
     VALUES
           ('3C02088E-3D7A-45D0-AF02-44F963DE1D72'
           ,'A65775BB-45B6-4FA7-B83B-7D6018719AF2'
           ,'8281DF90-4EBA-4E20-9487-DF5034DE0C9C'
           ,'9774766B-F49A-46B9-870A-8203D7F04B1C'
           ,'1'
           ,'0'
           ,'0')

INSERT INTO [Scenario].[activityContext]
           ([activityContext_id]
           ,[activityContext_activityId]
           ,[activityContext_clientSessionId]
           ,[activityContext_contextItemId]
           ,[activityContext_overridingData])
     VALUES
           ('D2E16A4E-A801-4AD7-B68D-E965D5BF3A60'
           ,'3C02088E-3D7A-45D0-AF02-44F963DE1D72'
           ,'C75934D8-9F52-4AC9-A134-002C4983550B'
           ,'40D9B3A2-A775-4404-83D0-8E630CB1CEB6'
           ,'overridingData.xml')
/* MEF Execution Activity */

/*  SQL Server Execution */
INSERT INTO [SQLServerExecution].[sqlServerExecution]
           ([sqlServerExecution_id]
           ,[sqlServerExecution_name]
           ,[sqlServerExecution_sqlQuery])
     VALUES
           ('E4782372-3F36-4468-9571-DE3E808932DB'
           ,'sqlServerExecutionName'
           ,'sqlServerExecutionSqlQuery')

INSERT INTO [SQLServerExecution].[sqlServerExecutionContext]
           ([sqlServerExecutionContext_id]
           ,[sqlServerExecutionContext_name]
           ,[sqlServerExecutionContext_connectionString]
           ,[sqlServerExecutionContext_isEncryptedConnectionString])
     VALUES
           ('22B3D012-7AC2-47BD-9D44-E76919F0C51A'
            ,'sqlServerExecutionContextName'
           ,convert(varbinary(MAX),'connectionString')
           ,'0')

INSERT INTO [SQLServerExecution].[sqlServerExecutionParameter]
           ([sqlServerExecutionParameter_id]
           ,[sqlServerExecutionParameter_name]
           ,[sqlServerExecutionParameter_value]
           ,[sqlServerExecutionParameter_sqlValueTypeId]
           ,[sqlServerExecutionParameter_sqlServerExecutionContextId])
     VALUES
           ('847DC5B4-88CA-4DBF-9CA8-2ACB0B80CF85'
           ,'sqlServerExecutionParameterName'
           ,CONVERT(varbinary(MAX), 'sqlServerExecutionParameterValue')
           ,'65a98742-b90b-4735-8349-7a3ab63e7f44'
           ,'22B3D012-7AC2-47BD-9D44-E76919F0C51A')

INSERT INTO [Scenario].[activity]
        ([activity_id]
           ,[activity_testScenarioId]
           ,[activity_activityTypeId]
           ,[activity_activityItemId]
           ,[activity_executionOrder]
           ,[activity_preWaitingTimeInSeconds]
           ,[activity_postWaitingTimeInSeconds])
     VALUES
           ('5EC54672-35F0-4685-AE7C-15D0689ECFC6'
           ,'A65775BB-45B6-4FA7-B83B-7D6018719AF2'
           ,'3F912BC2-E647-46A1-9B1A-B76D06FED3EA'
           ,'E4782372-3F36-4468-9571-DE3E808932DB'
           ,'3'
           ,'0'
           ,'0')

INSERT INTO [Scenario].[activityContext]
           ([activityContext_id]
           ,[activityContext_activityId]
           ,[activityContext_clientSessionId]
           ,[activityContext_contextItemId]
           ,[activityContext_overridingData])
     VALUES
           ('A55B4B99-358F-4556-ACEB-4F80D24EAF7E'
           ,'5EC54672-35F0-4685-AE7C-15D0689ECFC6'
            ,'C75934D8-9F52-4AC9-A134-002C4983550B'
           ,'22B3D012-7AC2-47BD-9D44-E76919F0C51A'
           ,'overridingData.xml')
/* END SQL Server Execution */

/* SQL CE Execution */
INSERT INTO [SQLCEExecution].[sqlceExecution]
           ([sqlceExecution_id]
           ,[sqlceExecution_name]
           ,[sqlceExecution_sqlQuery])
     VALUES
           ('BE915A1D-191E-4766-B945-339F1F5E9574'
           ,'sqlceExecutionName'
           ,'sqlceExecutionSqlQuery')

INSERT INTO [SQLCEExecution].[sqlceExecutionContext]
           ([sqlceExecutionContext_id]
           ,[sqlceExecutionContext_name]
           ,[sqlceExecutionContext_connectionString]
           ,[sqlceExecutionContext_isEncryptedConnectionString])
     VALUES
           ('B61D4C74-3CA4-4AE4-BECB-34B1818236FD'
           ,'sqlceExecutionContextName'
           ,convert(varbinary(MAX),'connectionString')
           ,'0')

INSERT INTO [SQLCEExecution].[sqlceExecutionParameter]
           ([sqlceExecutionParameter_id]
           ,[sqlceExecutionParameter_name]
           ,[sqlceExecutionParameter_value]
           ,[sqlceExecutionParameter_sqlValueTypeId]
           ,[sqlceExecutionParameter_sqlceExecutionContextId])
     VALUES
           ('90DE9599-1207-494E-8A0C-0C6CEBAE15EC'
           ,'sqlceExecutionParameterName'
           ,CONVERT(varbinary(MAX), 'sqlceExecutionParameterValue')
           ,'65a98742-b90b-4735-8349-7a3ab63e7f44'
           ,'B61D4C74-3CA4-4AE4-BECB-34B1818236FD')		   

INSERT INTO [Scenario].[activity]
        ([activity_id]
           ,[activity_testScenarioId]
           ,[activity_activityTypeId]
           ,[activity_activityItemId]
           ,[activity_executionOrder]
           ,[activity_preWaitingTimeInSeconds]
           ,[activity_postWaitingTimeInSeconds])
     VALUES
           ('68F62FA9-6872-45F1-8E89-5E31B1C634ED'
           ,'A65775BB-45B6-4FA7-B83B-7D6018719AF2'
           ,'A41A6035-AE9F-4397-84AC-1D396E6FC409'
           ,'BE915A1D-191E-4766-B945-339F1F5E9574'
           ,'2'
           ,'0'
           ,'0')
INSERT INTO [Scenario].[activityContext]
           ([activityContext_id]
           ,[activityContext_activityId]
           ,[activityContext_clientSessionId]
           ,[activityContext_contextItemId]
           ,[activityContext_overridingData])
     VALUES
           ('5D95A4B2-3E0A-4499-A544-9F084B98A6E4'
           ,'68F62FA9-6872-45F1-8E89-5E31B1C634ED'
           ,'C75934D8-9F52-4AC9-A134-002C4983550B'
           ,'B61D4C74-3CA4-4AE4-BECB-34B1818236FD'
           ,'overridingData.xml')
/* END SQL CE Execution */